root Element

root

Sequence

Choice 1..∞

vats

Sequence

vat 1..∞

code required xs:string

Sequence

description xs:string

percentage xs:decimal

countrydescription xs:string

isocountrycode xs:string

followupnumber xs:byte

dimensions

Sequence

dimension 1..∞

shortdescription required xs:string

Sequence

description xs:string

isodimensioncode xs:string

packages

Sequence

package 1..∞

shortdescription required xs:string

Sequence

description xs:string

isopackagecode xs:string

countries

Sequence

country 1..∞

isocountrycode required xs:string

Sequence

description xs:string

followupnumber xs:short

cbs_code xs:string

cashregistergroups

Sequence

cashregistergroup 1..∞

code required xs:string

Sequence

description xs:string

shortdescription xs:string

followupnumber xs:byte

loyaltycardpercentage xs:string

ispospromotion xs:boolean

productcategories

Sequence

productcategory 1..∞

code required xs:string

Sequence

externalannouncementcode xs:string

description xs:string

followupnumber xs:byte

cashregistergroupcode xs:string

minimalmargin xs:string

maximalmargin xs:string

loyaltycardpercentage xs:string

isstockvaluebyproductcategory xs:boolean

ispospromotion xs:boolean

margin xs:string

assortments

Sequence

assortment 1..∞

assortmenttypevalue required xs:byte

code required xs:string

Sequence

shortdescription xs:string

description xs:string

ispurchaseassortment xs:string

brands

Sequence

brand 1..∞

code required xs:string

Sequence

description xs:string

classifications

Sequence

classification1 1..∞

code required xs:string

Sequence

description xs:string

productcategorycode xs:string

ispospromotion xs:string

loyaltycardpercentage xs:string

followupnumber xs:byte

classification2 1..∞

code required xs:string

Sequence

description xs:string

productcategorycode

classification3 1..∞

code required xs:string

Sequence

description xs:string

productcategorycode xs:string

colors

basecharacteristics

characteristics

ExternalProducts

Sequence

ExternalProduct 1..∞

code required xs:string

Sequence

description xs:string

classification1code xs:string

classification2code xs:string

classification3code xs:string

classification4code xs:string

classification5code xs:string

note1 xs:string

searchtext

extprodcharacteristics

salutations

Sequence

salutation 1..∞

Sequence

shortdescription xs:string

description xs:string

customers

customercontacts

phonenumbers

suppliers

Sequence

supplier 1..∞

suppliernumber required xs:long

Sequence

generalname xs:string

vatcode xs:string

defaultgrossprofitpercentage xs:decimal

bank xs:string

giro xs:string

iban xs:string

swift xs:string

defaultcommunicationtype xs:string

gs1ediformat xs:string

gs1edipartynumber xs:long

porowordertype xs:string

poftpsubfolder

poemailaddress

suppliertype xs:string

information xs:string

greenleafnumber xs:integer

iscancelled xs:boolean

orderdiscountexecuteorder xs:integer

performancediscountexecuteorder xs:integer

freediscount1executeorder xs:integer

freediscount2executeorder xs:integer

conditionvalues

Sequence optional

value 1..∞

Sequence

discounttype xs:string

datefrom xs:dateTime

dateto xs:dateTime

value xs:decimal

description xs:string

freebitfield1 xs:boolean

seasonprofiles

classificationgroups

storetypedifferentiations

Sequence

storetypedifferentiation 1..∞

code required xs:string

Sequence

description xs:string

articlegroups

purchasestatusses

<xs:element name="root" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:complexType>
    <xs:sequence>
      <xs:choice maxOccurs="unbounded">
        <xs:element name="vats">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="vat">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="description" type="xs:string" />
                    <xs:element name="percentage" type="xs:decimal" />
                    <xs:element name="countrydescription" type="xs:string" />
                    <xs:element name="isocountrycode" type="xs:string" />
                    <xs:element name="followupnumber" type="xs:byte" />
                  </xs:sequence>
                  <xs:attribute name="code" type="xs:string" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dimensions">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="dimension">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="description" type="xs:string" />
                    <xs:element name="isodimensioncode" type="xs:string" />
                  </xs:sequence>
                  <xs:attribute name="shortdescription" type="xs:string" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="packages">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="package">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="description" type="xs:string" />
                    <xs:element name="isopackagecode" type="xs:string" />
                  </xs:sequence>
                  <xs:attribute name="shortdescription" type="xs:string" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="countries">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="country">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="description" type="xs:string" />
                    <xs:element name="followupnumber" type="xs:short" />
                    <xs:element name="cbs_code" type="xs:string" />
                  </xs:sequence>
                  <xs:attribute name="isocountrycode" type="xs:string" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="cashregistergroups">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="cashregistergroup">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="description" type="xs:string" />
                    <xs:element name="shortdescription" type="xs:string" />
                    <xs:element name="followupnumber" type="xs:byte" />
                    <xs:element name="loyaltycardpercentage" type="xs:string" />
                    <xs:element name="ispospromotion" type="xs:boolean" />
                  </xs:sequence>
                  <xs:attribute name="code" type="xs:string" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="productcategories">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="productcategory">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="externalannouncementcode" type="xs:string" />
                    <xs:element name="description" type="xs:string" />
                    <xs:element name="followupnumber" type="xs:byte" />
                    <xs:element name="cashregistergroupcode" type="xs:string" />
                    <xs:element name="minimalmargin" type="xs:string" />
                    <xs:element name="maximalmargin" type="xs:string" />
                    <xs:element name="loyaltycardpercentage" type="xs:string" />
                    <xs:element name="isstockvaluebyproductcategory" type="xs:boolean" />
                    <xs:element name="ispospromotion" type="xs:boolean" />
                    <xs:element name="margin" type="xs:string" />
                  </xs:sequence>
                  <xs:attribute name="code" type="xs:string" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="assortments">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="assortment">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="shortdescription" type="xs:string" />
                    <xs:element name="description" type="xs:string" />
                    <xs:element name="ispurchaseassortment" type="xs:string" />
                  </xs:sequence>
                  <xs:attribute name="assortmenttypevalue" type="xs:byte" use="required" />
                  <xs:attribute name="code" type="xs:string" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="brands">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="brand">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="description" type="xs:string" />
                  </xs:sequence>
                  <xs:attribute name="code" type="xs:string" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="classifications">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="classification1">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="description" type="xs:string" />
                    <xs:element name="productcategorycode" type="xs:string" />
                    <xs:element name="ispospromotion" type="xs:string" />
                    <xs:element name="loyaltycardpercentage" type="xs:string" />
                    <xs:element name="followupnumber" type="xs:byte" />
                    <xs:element maxOccurs="unbounded" name="classification2">
                      <xs:complexType>
                        <xs:sequence>
                          <xs:element name="description" type="xs:string" />
                          <xs:element name="productcategorycode" />
                          <xs:element maxOccurs="unbounded" name="classification3">
                            <xs:complexType>
                              <xs:sequence>
                                <xs:element name="description" type="xs:string" />
                                <xs:element name="productcategorycode" type="xs:string" />
                              </xs:sequence>
                              <xs:attribute name="code" type="xs:string" use="required" />
                            </xs:complexType>
                          </xs:element>
                        </xs:sequence>
                        <xs:attribute name="code" type="xs:string" use="required" />
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                  <xs:attribute name="code" type="xs:string" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="colors" />
        <xs:element name="basecharacteristics" />
        <xs:element name="characteristics" />
        <xs:element name="ExternalProducts">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="ExternalProduct">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="description" type="xs:string" />
                    <xs:element name="classification1code" type="xs:string" />
                    <xs:element name="classification2code" type="xs:string" />
                    <xs:element name="classification3code" type="xs:string" />
                    <xs:element name="classification4code" type="xs:string" />
                    <xs:element name="classification5code" type="xs:string" />
                    <xs:element name="note1" type="xs:string" />
                    <xs:element name="searchtext" />
                  </xs:sequence>
                  <xs:attribute name="code" type="xs:string" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="extprodcharacteristics" />
        <xs:element name="salutations">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="salutation">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="shortdescription" type="xs:string" />
                    <xs:element name="description" type="xs:string" />
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="customers" />
        <xs:element name="customercontacts" />
        <xs:element name="phonenumbers" />
        <xs:element name="suppliers">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="supplier">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="generalname" type="xs:string" />
                    <xs:element name="vatcode" type="xs:string" />
                    <xs:element name="defaultgrossprofitpercentage" type="xs:decimal" />
                    <xs:element name="bank" type="xs:string" />
                    <xs:element name="giro" type="xs:string" />
                    <xs:element name="iban" type="xs:string" />
                    <xs:element name="swift" type="xs:string" />
                    <xs:element name="defaultcommunicationtype" type="xs:string" />
                    <xs:element name="gs1ediformat" type="xs:string" />
                    <xs:element name="gs1edipartynumber" type="xs:long" />
                    <xs:element name="porowordertype" type="xs:string" />
                    <xs:element name="poftpsubfolder" />
                    <xs:element name="poemailaddress" />
                    <xs:element name="suppliertype" type="xs:string" />
                    <xs:element name="information" type="xs:string" />
                    <xs:element name="greenleafnumber" type="xs:integer" nillable="true" />
                    <xs:element name="iscancelled" type="xs:boolean" />
                    <xs:element name="orderdiscountexecuteorder" type="xs:integer" />
                    <xs:element name="performancediscountexecuteorder" type="xs:integer" />
                    <xs:element name="freediscount1executeorder" type="xs:integer" />
                    <xs:element name="freediscount2executeorder" type="xs:integer" />
                    <xs:element name="conditionvalues">
                      <xs:complexType>
                        <xs:sequence minOccurs="0">
                          <xs:element maxOccurs="unbounded" name="value">
                            <xs:complexType>
                              <xs:sequence>
                                <xs:element name="discounttype" type="xs:string" />
                                <xs:element name="datefrom" type="xs:dateTime" />
                                <xs:element name="dateto" type="xs:dateTime" />
                                <xs:element name="value" type="xs:decimal" />
                                <xs:element name="description" type="xs:string" />
                                <xs:element name="freebitfield1" type="xs:boolean" />
                              </xs:sequence>
                            </xs:complexType>
                          </xs:element>
                        </xs:sequence>
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                  <xs:attribute name="suppliernumber" type="xs:long" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="seasonprofiles" />
        <xs:element name="classificationgroups" />
        <xs:element name="storetypedifferentiations">
          <xs:complexType>
            <xs:sequence>
              <xs:element maxOccurs="unbounded" name="storetypedifferentiation">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element name="description" type="xs:string" />
                  </xs:sequence>
                  <xs:attribute name="code" type="xs:string" use="required" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="articlegroups" />
        <xs:element name="purchasestatusses" />
      </xs:choice>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Offline Basetables export v3 Schema